2013-04-10 - 5910.200 - Rel Notes - Contracts - Release 032 #BIReleases2013
Release Notes:
5910.200 - Contracts - SA130
Admin Info
Purpose
|
Including Contract Information in SA130 report
|
Release No
|
032
|
Submitted
|
04-10-2013
|
Submitted by
|
Mallareddy D
|
Source/Destination Systems
|
IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
|
Release Sent To
|
Mark Harris
|
Object(s) Created By
|
Mallareddy D
|
Object(s) Tested By
|
Naga Brahmam R
|
Report Name
SA130 - Miami Scorecard
BEx Query
ZMP_OOCON_Q004
ZMP_OOCON_Q003
ZMP_OOCON_Q005
ZMP_OPASA_Q014
ZZCOPA_C03_043
ZSDC_SSL_005
NEC Crystal Reports Standards Check
1. SA130 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. SA130 NEC CR checklist has been sent to NEC and also attached here for reference:
Open Orders by Season - OSA130 Sub Report Validation
Test Conducted
Grouping: Sales Org > CUSTOM
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
No. of Orders
|
1,786
|
1,786
|
Pass
|
2
|
Confirmed Qty
|
1,511,051
|
1,511,051
|
Pass
|
3
|
Sales Org Currency
|
14,929,967
|
14,929,966.50
|
Pass
|
4
|
Corporate Currency
|
14,981,253
|
14,981,252.99
|
Pass
|
Open Orders by Fiscal Year - OSA100 Sub Report Validation
Test Conducted
Grouping: Sales Org > 5th & Ocean > 2013 > October 2013
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
No. of Orders
|
7
|
7
|
Pass
|
2
|
Confirmed Qty
|
1200
|
1200
|
Pass
|
3
|
Sales Org Currency
|
27,584
|
27,583.68
|
Pass
|
4
|
Corporate Currency
|
27,584
|
27,583.68
|
Pass
|
Open Orders at Risk of Cancel - OSA172 Sub Report Validation
Test Conducted
Grouping: Sales Org > 5th & Ocean
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
No. of Orders
|
468
|
468
|
Pass
|
2
|
Confirmed Qty
|
46,091
|
46,091
|
Pass
|
3
|
Sales Org Currency
|
390,611
|
390,611.03
|
Pass
|
4
|
Corporate Currency
|
390,611
|
390,611.03
|
Pass
|
Sales Analysis by Sales Org - SA900 Sub Report Validation
Test Conducted
Grouping: Sales Org - 5th & Ocean > VICTORIAS SECRET >2013
SNo
|
Test Case
|
Value in CR for 2013
|
Value in CR for 2012
|
Value in BEx of 2013
|
Value in BEx for 2012
|
Pass/Fail Criteria
|
1
|
Quantity
|
1,207,439
|
2,690,228
|
1,207,439
|
2,690,228
|
Pass
|
2
|
Sales Org Currency
|
10,851,049
|
31,915,738
|
10,851,049.44
|
31,915,737.94
|
Pass
|
3
|
Corporate Currency
|
10,851,049
|
31,915,738
|
10,851,049.44
|
31,915,737.94
|
Pass
|
Shipped and Open by Region - SA170 Sub Report Validation
Test Conducted
Grouping: Sales Org - ALL > EMEA > April
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Shipped
|
54,465
|
54,465.27
|
Pass
|
2
|
Open
|
88,768
|
88,767.51
|
Pass
|
3
|
Total
|
143,233
|
143,232.78
|
Pass
|
4
|
Last Year
|
93,862
|
93,861.93
|
Pass
|
5
|
Variance
|
49,371
|
49,370.85
|
Pass
|
6
|
Coverage %
|
153
|
152.59
|
Pass
|
Service Level - SL100 Sub Report Validation
Test Conducted
Grouping: United Sales > 2013 > May
SNo
|
Test Case
|
Value in CR
|
Value in BEx
|
Pass/Fail Criteria
|
1
|
Ordered
|
144
|
144
|
Pass
|
2
|
Delivered
|
144
|
144
|
Pass
|
3
|
Ontime
|
144
|
144
|
Pass
|
4
|
Late
|
0
|
0
|
Pass
|
5
|
Ontime %
|
100%
|
100%
|
Pass
|
6
|
Fill Rate %
|
100%
|
100%
|
Pass
|
7
|
Confirmed
|
144
|
144
|
Pass
|
8
|
Delivered
|
144
|
144
|
Pass
|
9
|
Ontime
|
0
|
0
|
Pass
|
10
|
Late
|
0
|
0
|
Pass
|
11
|
Ontime %
|
100%
|
100%
|
Pass
|
12
|
Fill Rate %
|
100%
|
100%
|
Pass
|
13
|
First Pass
|
144
|
144
|
Pass
|
14
|
First Pass %
|
100%
|
100%
|
Pass
|
Reference Document(Specification)
2013-03-15 - 5910.200 - Spec - Contract Reports